package org.itli.jnsocket.Mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.itli.jnsocket.Pojo.OnBound;
import org.itli.jnsocket.VTO.OutBindHistoryVTO;

import java.util.List;

@Mapper
public interface OnBindHistoryMapper {

    @Select("SELECT " +
            "id, " +
            "order_sn, " +
            "warehouse_id, " +
            "supplier_id, " +
            "supplier_no, " +
            "supplier_name, " +
            "purchase_amount, " +
            "purchase_type, " +
            "purchase_date, " +
            "pay_type " +
            "FROM jn_wms_purchase_order LIMIT #{size} OFFSET #{page}")
    List<OutBindHistoryVTO> CardInfo(int size, int page);

}
